<report xmlns="http://developer.cognos.com/schemas/report/12.0/" useStyleVersion="10" expressionLocale="en-us">
				<modelPath>/content/folder[@name=&apos;Packages&apos;]/package[@name=&apos;Storage and Storage Pool Capacity&apos;]/model[@name=&apos;2016-02-10T18:34:33.482Z&apos;]</modelPath>
				<drillBehavior/>
				<queries>
					<query name="Query1">
						<source>
							<model/>
						</source>
						<selection><dataItemLevelSet name="Storage"><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Storage]</LUN><itemCaption>Storage</itemCaption></dmLevel><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy></dataItemLevelSet><dataItemLevelSet name="Month"><dmLevel><LUN>[Physical Capacity].[Date].[Date].[Month]</LUN><itemCaption>Month</itemCaption></dmLevel><dmDimension><DUN>[Physical Capacity].[Date]</DUN><itemCaption>Date</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Date].[Date]</HUN><itemCaption>Date</itemCaption></dmHierarchy></dataItemLevelSet><dataItemMeasure name="Capacity (TB)"><dmMember><MUN>[Physical Capacity].[Capacity (TB)].[Capacity (TB)]</MUN><itemCaption>Capacity (TB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Capacity (TB)]</DUN><itemCaption>Capacity (TB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute output="no" name="RS_dataType" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Used Capacity (TB)"><dmMember><MUN>[Physical Capacity].[Capacity (TB)].[Used Capacity (TB)]</MUN><itemCaption>Used Capacity (TB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Capacity (TB)]</DUN><itemCaption>Capacity (TB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute output="no" name="RS_dataType" value="2"/></XMLAttributes></dataItemMeasure><dataItem aggregate="calculated" name="% (Used Capacity (TB), Capacity (TB))" label="Used (%)"><expression>[Used Capacity (TB)] / [Capacity (TB)]</expression><XMLAttributes><XMLAttribute output="no" name="RS_dataType" value="9"/><XMLAttribute output="no" name="RS_relationalExpression" value="true"/></XMLAttributes></dataItem></selection>
					</query>
				<query name="Query2">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_performance">
			<sqlText>
select `T1`.`C0` as &quot;memberUniqueName2&quot; , `T0`.`C1` as &quot;Storage&quot; , `T1`.`C1` as &quot;memberUniqueName4&quot; , `T1`.`C7` as &quot;Utilization____&quot; , `T1`.`C2` as &quot;family&quot; , `T1`.`C3` as &quot;model&quot; , `T1`.`C4` as &quot;identifier&quot; , `T1`.`C5` as &quot;quarterLabel&quot; , `T1`.`C6` as &quot;monthLabel&quot; 
 from (
select `storage_dimension`.`identifier` as &quot;C0&quot; , min(`storage_dimension`.`name`) as &quot;C1&quot; 
 from `storage_dimension` `storage_dimension`, `date_dimension` `date_dimension`, `storage_node_daily_performance_fact` `T3`
 where `storage_dimension`.`tk` = `T3`.`storageTk` and `date_dimension`.`tk` = `T3`.`dateTk`
 group by `storage_dimension`.`identifier`) `T0`, (
select `storage_dimension`.`manufacturer` as &quot;C0&quot; , `date_dimension`.`dateYear` as &quot;C1&quot; , `storage_dimension`.`family` as &quot;C2&quot; , `storage_dimension`.`model` as &quot;C3&quot; , `storage_dimension`.`identifier` as &quot;C4&quot; , `date_dimension`.`quarterLabel` as &quot;C5&quot; , `date_dimension`.`monthLabel` as &quot;C6&quot; , avg(`T3`.`utilization`) as &quot;C7&quot; 
 from `storage_dimension` `storage_dimension`, `date_dimension` `date_dimension`, `storage_node_daily_performance_fact` `T3`
 where `storage_dimension`.`tk` = `T3`.`storageTk` and `date_dimension`.`tk` = `T3`.`dateTk`
 group by `storage_dimension`.`manufacturer`, `date_dimension`.`dateYear`, `storage_dimension`.`family`, `storage_dimension`.`model`, `storage_dimension`.`identifier`, `date_dimension`.`quarterLabel`, `date_dimension`.`monthLabel`) `T1`
 where `T1`.`C4` = `T0`.`C0`</sqlText>
		<mdProjectedItems><mdProjectedItem name="memberUniqueName2"/><mdProjectedItem name="Storage"/><mdProjectedItem name="memberUniqueName4"/><mdProjectedItem name="Utilization____"/><mdProjectedItem name="family"/><mdProjectedItem name="model"/><mdProjectedItem name="identifier"/><mdProjectedItem name="quarterLabel"/><mdProjectedItem name="monthLabel"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="memberUniqueName2"><expression>[SQL1].[memberUniqueName2]</expression></dataItem><dataItem name="Storage"><expression>[SQL1].[Storage]</expression></dataItem><dataItem name="memberUniqueName4"><expression>[SQL1].[memberUniqueName4]</expression></dataItem><dataItem name="Utilization____"><expression>[SQL1].[Utilization____]</expression></dataItem><dataItem name="family"><expression>[SQL1].[family]</expression></dataItem><dataItem name="model"><expression>[SQL1].[model]</expression></dataItem><dataItem name="identifier"><expression>[SQL1].[identifier]</expression></dataItem><dataItem name="quarterLabel"><expression>[SQL1].[quarterLabel]</expression></dataItem><dataItem name="monthLabel"><expression>[SQL1].[monthLabel]</expression></dataItem></selection>
		</query><query name="Query3">
			<source>
				
			<joinOperation>
			<joinOperands>
				<joinOperand><queryRef refQuery="Query1"/></joinOperand>
				<joinOperand><queryRef refQuery="Query2"/></joinOperand>
			</joinOperands>
			<joinFilter>
				<filterExpression>[Query1].[Storage] = [Query2].[Storage] and
[Query1].[Month] = [Query2].[monthLabel]</filterExpression>
			</joinFilter>
		</joinOperation></source>
			<selection><dataItem rollupAggregate="none" name="Storage"><expression>[Query1].[Storage]</expression></dataItem><dataItem rollupAggregate="none" name="Month"><expression>[Query1].[Month]</expression></dataItem><dataItem name="Capacity (TB)" aggregate="average"><expression>[Query1].[Capacity (TB)]</expression></dataItem><dataItem name="Used Capacity (TB)" aggregate="average"><expression>[Query1].[Used Capacity (TB)]</expression></dataItem><dataItem name="Capacity Utilization" aggregate="average"><expression>[Query1].[% (Used Capacity (TB), Capacity (TB))]</expression></dataItem><dataItem name="Node Utilization" aggregate="average"><expression>[Query2].[Utilization____]/100</expression></dataItem></selection>
		</query></queries>
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<crosstab horizontalPagination="true" refQuery="Query3" name="Crosstab1">
			<crosstabCorner>
				<contents/>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="xm"/>
					</defaultStyles>
				</style>
			</crosstabCorner>
			
			
			
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="xt"/>
				</defaultStyles>
			</style>
		<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler><crosstabColumns><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Capacity (TB)" edgeLocation="e1"><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents><factCell><style/></factCell><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style></crosstabNodeMember><crosstabNodeMember refDataItem="Used Capacity (TB)" edgeLocation="e2"><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents><factCell><style/></factCell><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style></crosstabNodeMember><crosstabNodeMember refDataItem="Capacity Utilization" edgeLocation="e3"><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents><factCell><style><dataFormat><percentFormat decimalSize="2"/></dataFormat></style></factCell><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style></crosstabNodeMember><crosstabNodeMember refDataItem="Node Utilization" edgeLocation="e4"><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents><factCell><style><dataFormat><percentFormat decimalSize="2"/></dataFormat></style></factCell><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabNodeMember refDataItem="Month" edgeLocation="e5"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabColumns><crosstabRows><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Storage" edgeLocation="e6"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabRows><crosstabFactCell><contents><textItem><dataSource><cellValue/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="mv"/></defaultStyles></style></crosstabFactCell></crosstab></contents>
								</pageBody>
								<pageHeader>
									<contents>
										<block><style><defaultStyles><defaultStyle refStyle="ta"/></defaultStyles></style>
											<contents>
												<textItem><style><defaultStyles><defaultStyle refStyle="tt"/></defaultStyles></style>
													<dataSource>
														<staticValue>Storage Array Utilization Report by Month</staticValue>
													</dataSource>
												</textItem>
											</contents>
										</block>
									</contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="ph"/>
										</defaultStyles>
										<CSS value="padding-bottom:10px"/>
									</style>
								</pageHeader>
								<pageFooter>
									<contents>
										<table>
											<tableRows>
												<tableRow>
													<tableCells>
														<tableCell>
															<contents>
																<date>
																	<style>
																		<dataFormat>
																			<dateFormat/>
																		</dataFormat>
																	</style>
																</date>
															</contents>
															<style>
																<CSS value="vertical-align:top;text-align:left;width:25%"/>
															</style>
														</tableCell>
														<tableCell>
															<contents>
																<pageNumber/>
															</contents>
															<style>
																<CSS value="vertical-align:top;text-align:center;width:50%"/>
															</style>
														</tableCell>
														<tableCell>
															<contents>
																<time>
																	<style>
																		<dataFormat>
																			<timeFormat/>
																		</dataFormat>
																	</style>
																</time>
															</contents>
															<style>
																<CSS value="vertical-align:top;text-align:right;width:25%"/>
															</style>
														</tableCell>
													</tableCells>
												</tableRow>
											</tableRows>
											<style>
												<defaultStyles>
													<defaultStyle refStyle="tb"/>
												</defaultStyles>
												<CSS value="border-collapse:collapse;width:100%"/>
											</style>
										</table>
									</contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute output="no" name="RS_CreateExtendedDataItems" value="true"/><XMLAttribute output="no" name="listSeparator" value=","/><XMLAttribute output="no" name="RS_modelModificationTime" value="2016-04-21T17:59:04.190Z"/></XMLAttributes><reportName>Temp_How To Use A Cognos Join Output</reportName></report>